Hourly Avg Orders Sheet
14
1. Right click on Total Sales worksheet and select Duplicate. Rename the sheet as Hourly Avg Orders.
2. Drag and drop Order Time dimension to the Columns shelf. Right click on Order Time and select Hour from the drop down list.
3. Drag and drop Order Date dimension to the Rows shelf. Right click on Order Date and select Weekday from the drop down list.
4. Drag and drop the calculated column Avg Orders by Day to the Label shelf under Marks.
5.
Drag and drop the calculated column Avg Orders Hourly Legend to the
Color shelf under Marks. Click on Colors and select Edit Colors. Select
the colors as follows:
High - #b61500
Avg - #ff7400
Low - #ffac0e
6.
Drag and drop the calculated column Cell Background to Size shelf under
Marks. Right click on Cell background and select Minimum for Measure.
Select Chart type = Bar.
7. Right click on Y-axis label
and select Format. Under Default > Font = Tableau Light, Dates =
Abbreviation. Right click on Weekday of Order Date and select Hide
labels for row headers.
8. Right click on X-Axis label,
and select Format. Under Default> Font = Tableau Semibold, Dates =
12-hour, Size=8. Right click on Order Time and select Hide labels for
column headers.
9. Drag and drop Date Filter to Filters shelf and select only True option.
10. Click on Tooltip under Marks and enter the following:
Weekday: <WEEKDAY(Order Date)>
Hour : <HOUR(Order Time)>
Total Sales: <SUM(Total Price)>
Sales MoM: <AGG(Sales MoM %)>
Avg Orders: <AGG(Avg Orders By Day)>
Orders MoM:<AGG(Orders MoM %)>
Avg Price:<AGG(Avg Pizza Price)>
Avg Price MoM:<AGG(Avg Price MoM %)>
Font = Tableau Book, Size = 8, Bold, Alignment = Left
11. Right click on Title and select Edit Title and enter Avg Customer Orders.
Follow the Gif files below for step by step instructions:
Conditional formatting in Tableau